home *** CD-ROM | disk | FTP | other *** search
/ Reverse Code Engineering RCE CD +sandman 2000 / ReverseCodeEngineeringRceCdsandman2000.iso / RCE / Ebooks / Database C++4 / 08vcg02.gif < prev    next >
Graphics Interchange Format  |  2000-05-25  |  16.3 KB  |  417x200  |  8-bit (149 colors)
   ocr: SQL 4 SQL Statement OK SELECT Categories. "Category ID"AS Cat, Cancel (fn MONTH(Orders. "Order Date")AS Month, Sum("Order Details"."Unit Price" * "Order Details".Quantity)AS Sales FROM Categories, "Order Details", Orders, Products WHERE Products. "Category ID"= Categories. "Category ID" AND "Order Details"."Order ID" = Orders. "Order ID" AND "Order Detalls"."Product ID" == Products. 'Product ID" GROUP BY Categories." "Category ID".ffn MONTH(Orders." - "Order Date"))